package com.huatai.bi.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.huatai.bi.entity.BigScreenPageEntity;
import com.huatai.bi.vo.bigScreenVO.DownTreeListVO;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author hecai
* @description 针对表【big_screen_page(态势模板)】的数据库操作Mapper
* @createDate 2024-06-20 14:11:51
* @Entity com.huatai.bi.BigScreenPage
*/
public interface BigScreenPageMapper extends BaseMapper<BigScreenPageEntity> {

	@Select(" SELECT " +
		" A.p_id, " +
		" A.id,b.id as bigScreenId, " +
		" A.NAME AS typeName, " +
		" b.NAME AS bigScreenName, " +
		" b.code  " +
		"FROM " +
		" big_screen_type AS A  " +
		" LEFT JOIN big_screen_page AS b ON A.code = b.parent_code ")
	List<DownTreeListVO> getDownTreeList();

}




